Order Management System Environment Configuration

Purpose: This topic describes the setup required by cloud administration staff to configure a database connection for Order Management System.

DBConfig Properties File

Use the dbconfig.properties file on the application server to configure database connection settings for Order Management System Cloud Service. This file contains the database information required to connect to each Order Management System Cloud Service database.

When to update this file: The system updates this file automatically during the installation process. Cloud administration staff will need to update this file if you change your database server, database name, or database login; otherwise, the information in this file should not be changed.

Location of file: This file is normally saved on the application server at domain/conf/jenasysproperties, where domain is the WebLogic domain directory for Order Management System.

To edit the file: Cloud administration staff can review and update this file using a text editor. If Cloud administration staff make any changes to the DBConfig Properties file, Cloud administration staff must restart Order Management System Cloud Service before the changes take effect.

The settings in this file that Cloud administration staff might wish to review or edit are explained below.

Setting	Description
environment	The name of the Order Management System Cloud Service database environment. Change this setting to the name of your Order Management System Cloud Service environment.
db.machine.name	The name of the database server where the Order Management System Cloud Service database is located.
db.url	The connection information used to connect to the Order Management System Cloud Service database: jdbc:oracle:thin:@//hostname.us.oracle.com:9999/servicename where: • hostname = The Hostname defined for the database connection. • 9999 = The port used to connect to the database. • servicename = The Service name defined for the database connection.
db.user.name	The user ID used to connect to the Order Management System Cloud Service database server. This should be ORDER_MANAGEMENT.
db.password	The user’s database password used to connect to the Order Management System Cloud Service database server. The password entry here is encrypted. If Cloud administration staff change the database password as part of your security standards, Cloud administration staff must change this value and then restart Order Management System Cloud Service.